{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "na_vals = [\"NA\", \"Missing\"] # making list of which ones can be null values\n",
    "\n",
    "df = pd.read_csv('surveydata/survey_results_public.csv', index_col = \"Respondent\", na_values = na_vals)\n",
    "s_df = pd.read_csv('surveydata/survey_results_schema.csv', index_col = \"Column\")\n",
    "\n",
    "pd.set_option('display.max_columns', 61)\n",
    "pd.set_option('display.max_rows', 61)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MainBranch</th>\n",
       "      <th>Hobbyist</th>\n",
       "      <th>Age</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>ConvertedComp</th>\n",
       "      <th>Country</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>DatabaseDesireNextYear</th>\n",
       "      <th>DatabaseWorkedWith</th>\n",
       "      <th>DevType</th>\n",
       "      <th>EdLevel</th>\n",
       "      <th>Employment</th>\n",
       "      <th>Ethnicity</th>\n",
       "      <th>Gender</th>\n",
       "      <th>JobFactors</th>\n",
       "      <th>JobSat</th>\n",
       "      <th>JobSeek</th>\n",
       "      <th>LanguageDesireNextYear</th>\n",
       "      <th>LanguageWorkedWith</th>\n",
       "      <th>MiscTechDesireNextYear</th>\n",
       "      <th>MiscTechWorkedWith</th>\n",
       "      <th>NEWCollabToolsDesireNextYear</th>\n",
       "      <th>NEWCollabToolsWorkedWith</th>\n",
       "      <th>NEWDevOps</th>\n",
       "      <th>NEWDevOpsImpt</th>\n",
       "      <th>NEWEdImpt</th>\n",
       "      <th>NEWJobHunt</th>\n",
       "      <th>NEWJobHuntResearch</th>\n",
       "      <th>NEWLearn</th>\n",
       "      <th>NEWOffTopic</th>\n",
       "      <th>NEWOnboardGood</th>\n",
       "      <th>NEWOtherComms</th>\n",
       "      <th>NEWOvertime</th>\n",
       "      <th>NEWPurchaseResearch</th>\n",
       "      <th>NEWPurpleLink</th>\n",
       "      <th>NEWSOSites</th>\n",
       "      <th>NEWStuck</th>\n",
       "      <th>OpSys</th>\n",
       "      <th>OrgSize</th>\n",
       "      <th>PlatformDesireNextYear</th>\n",
       "      <th>PlatformWorkedWith</th>\n",
       "      <th>PurchaseWhat</th>\n",
       "      <th>Sexuality</th>\n",
       "      <th>SOAccount</th>\n",
       "      <th>SOComm</th>\n",
       "      <th>SOPartFreq</th>\n",
       "      <th>SOVisitFreq</th>\n",
       "      <th>SurveyEase</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>Trans</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>WebframeDesireNextYear</th>\n",
       "      <th>WebframeWorkedWith</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Germany</td>\n",
       "      <td>European Euro</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Microsoft SQL Server</td>\n",
       "      <td>Elasticsearch;Microsoft SQL Server;Oracle</td>\n",
       "      <td>Developer, desktop or enterprise applications;...</td>\n",
       "      <td>Master’s degree (M.A., M.S., M.Eng., MBA, etc.)</td>\n",
       "      <td>Independent contractor, freelancer, or self-em...</td>\n",
       "      <td>White or of European descent</td>\n",
       "      <td>Man</td>\n",
       "      <td>Languages, frameworks, and other technologies ...</td>\n",
       "      <td>Slightly satisfied</td>\n",
       "      <td>I am not interested in new job opportunities</td>\n",
       "      <td>C#;HTML/CSS;JavaScript</td>\n",
       "      <td>C#;HTML/CSS;JavaScript</td>\n",
       "      <td>.NET Core;Xamarin</td>\n",
       "      <td>.NET;.NET Core</td>\n",
       "      <td>Microsoft Teams;Microsoft Azure;Trello</td>\n",
       "      <td>Confluence;Jira;Slack;Microsoft Azure;Trello</td>\n",
       "      <td>No</td>\n",
       "      <td>Somewhat important</td>\n",
       "      <td>Fairly important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>Not sure</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>Often: 1-2 days per week or more</td>\n",
       "      <td>Start a free trial;Ask developers I know/work ...</td>\n",
       "      <td>Amused</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who codes)</td>\n",
       "      <td>Visit Stack Overflow;Go for a walk or other ph...</td>\n",
       "      <td>Windows</td>\n",
       "      <td>2 to 9 employees</td>\n",
       "      <td>Android;iOS;Kubernetes;Microsoft Azure;Windows</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>No</td>\n",
       "      <td>No, not at all</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Multiple times per day</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>ASP.NET Core</td>\n",
       "      <td>ASP.NET;ASP.NET Core</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>50.0</td>\n",
       "      <td>36</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Pound sterling</td>\n",
       "      <td>GBP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Developer, full-stack;Developer, mobile</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Very dissatisfied</td>\n",
       "      <td>I am not interested in new job opportunities</td>\n",
       "      <td>Python;Swift</td>\n",
       "      <td>JavaScript;Swift</td>\n",
       "      <td>React Native;TensorFlow;Unity 3D</td>\n",
       "      <td>React Native</td>\n",
       "      <td>Github;Slack</td>\n",
       "      <td>Confluence;Jira;Github;Gitlab;Slack</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Fairly important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>Not sure</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Amused</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>Visit Stack Overflow;Go for a walk or other ph...</td>\n",
       "      <td>MacOS</td>\n",
       "      <td>1,000 to 4,999 employees</td>\n",
       "      <td>iOS;Kubernetes;Linux;MacOS</td>\n",
       "      <td>iOS</td>\n",
       "      <td>I have little or no influence</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, definitely</td>\n",
       "      <td>Less than once per month or monthly</td>\n",
       "      <td>Multiple times per day</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Somewhat more welcome now than last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>I code primarily as a hobby</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Objective-C;Python;Swift</td>\n",
       "      <td>Objective-C;Python;Swift</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a decade</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who codes)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Linux-based</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, somewhat</td>\n",
       "      <td>A few times per month or weekly</td>\n",
       "      <td>Daily or almost daily</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Somewhat more welcome now than last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>25.0</td>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Albania</td>\n",
       "      <td>Albanian lek</td>\n",
       "      <td>ALL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Master’s degree (M.A., M.S., M.Eng., MBA, etc.)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>White or of European descent</td>\n",
       "      <td>Man</td>\n",
       "      <td>Flex time or a flexible schedule;Office enviro...</td>\n",
       "      <td>Slightly dissatisfied</td>\n",
       "      <td>I’m not actively looking, but I am open to new...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Not at all important/not necessary</td>\n",
       "      <td>Curious about other opportunities;Wanting to w...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>Not sure</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Occasionally: 1-2 days per quarter but less th...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Linux-based</td>\n",
       "      <td>20 to 99 employees</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>I have a great deal of influence</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, definitely</td>\n",
       "      <td>A few times per month or weekly</td>\n",
       "      <td>Multiple times per day</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Somewhat less welcome now than last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>I used to be a developer by profession, but no...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>31.0</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MySQL;PostgreSQL</td>\n",
       "      <td>MySQL;PostgreSQL;Redis;SQLite</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bachelor’s degree (B.A., B.S., B.Eng., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>White or of European descent</td>\n",
       "      <td>Man</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java;Ruby;Scala</td>\n",
       "      <td>HTML/CSS;Ruby;SQL</td>\n",
       "      <td>Ansible;Chef</td>\n",
       "      <td>Ansible</td>\n",
       "      <td>Github;Google Suite (Docs, Meet, etc)</td>\n",
       "      <td>Confluence;Jira;Github;Slack;Google Suite (Doc...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Very important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial;Ask developers I know/work ...</td>\n",
       "      <td>Hello, old friend</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who code...</td>\n",
       "      <td>Call a coworker or friend;Visit Stack Overflow...</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Docker;Google Cloud Platform;Heroku;Linux;Windows</td>\n",
       "      <td>AWS;Docker;Linux;MacOS;Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, somewhat</td>\n",
       "      <td>Less than once per month or monthly</td>\n",
       "      <td>A few times per month or weekly</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Too short</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Django;Ruby on Rails</td>\n",
       "      <td>Ruby on Rails</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64858</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Senior executive/VP</td>\n",
       "      <td>Master’s degree (M.A., M.S., M.Eng., MBA, etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Very important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a decade</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial</td>\n",
       "      <td>Amused</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who codes)</td>\n",
       "      <td>Call a coworker or friend</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>Less than 1 year</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64867</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cassandra;Couchbase;DynamoDB;Elasticsearch;Fir...</td>\n",
       "      <td>Cassandra;Couchbase;DynamoDB;Elasticsearch;Fir...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assembly;Bash/Shell/PowerShell;C;C#;C++;Dart;G...</td>\n",
       "      <td>Assembly;Bash/Shell/PowerShell;C;C#;C++;Dart;G...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64898</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Primary/elementary school</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64925</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DynamoDB;Elasticsearch;MongoDB;MySQL;PostgreSQL</td>\n",
       "      <td>Oracle</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HTML/CSS;Java;JavaScript</td>\n",
       "      <td>HTML/CSS</td>\n",
       "      <td>Node.js</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Github;Gitlab</td>\n",
       "      <td>Confluence;Jira;Slack;Microsoft Teams</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial</td>\n",
       "      <td>Hello, old friend</td>\n",
       "      <td>Stack Overflow (public Q&amp;A for anyone who codes)</td>\n",
       "      <td>Call a coworker or friend;Visit Stack Overflow</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Linux;Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Angular;Angular.js;React.js</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65112</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MariaDB;Microsoft SQL Server</td>\n",
       "      <td>MariaDB;Microsoft SQL Server;MySQL;Oracle</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other doctoral degree (Ph.D., Ed.D., etc.)</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C#;HTML/CSS;Java;JavaScript;SQL</td>\n",
       "      <td>C#;HTML/CSS;Java;JavaScript;SQL</td>\n",
       "      <td>.NET Core;Xamarin</td>\n",
       "      <td>.NET;.NET Core</td>\n",
       "      <td>Github;Microsoft Teams</td>\n",
       "      <td>Github</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Critically important</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Once a year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Start a free trial;Ask developers I know/work ...</td>\n",
       "      <td>Indifferent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Meditate;Visit Stack Overflow;Go for a walk or...</td>\n",
       "      <td>Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Arduino;Linux;Raspberry Pi;Windows</td>\n",
       "      <td>Android;Arduino;Linux;Raspberry Pi;Windows</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>ASP.NET Core;jQuery</td>\n",
       "      <td>Angular;Angular.js;ASP.NET Core;jQuery</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>64461 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   MainBranch Hobbyist   Age  \\\n",
       "Respondent                                                                     \n",
       "1                              I am a developer by profession      Yes   NaN   \n",
       "2                              I am a developer by profession       No   NaN   \n",
       "3                                 I code primarily as a hobby      Yes   NaN   \n",
       "4                              I am a developer by profession      Yes  25.0   \n",
       "5           I used to be a developer by profession, but no...      Yes  31.0   \n",
       "...                                                       ...      ...   ...   \n",
       "64858                                                     NaN      Yes   NaN   \n",
       "64867                                                     NaN      Yes   NaN   \n",
       "64898                                                     NaN      Yes   NaN   \n",
       "64925                                                     NaN      Yes   NaN   \n",
       "65112                                                     NaN      Yes   NaN   \n",
       "\n",
       "           Age1stCode CompFreq  CompTotal  ConvertedComp             Country  \\\n",
       "Respondent                                                                     \n",
       "1                  13  Monthly        NaN            NaN             Germany   \n",
       "2                  19      NaN        NaN            NaN      United Kingdom   \n",
       "3                  15      NaN        NaN            NaN  Russian Federation   \n",
       "4                  18      NaN        NaN            NaN             Albania   \n",
       "5                  16      NaN        NaN            NaN       United States   \n",
       "...               ...      ...        ...            ...                 ...   \n",
       "64858              16      NaN        NaN            NaN       United States   \n",
       "64867             NaN      NaN        NaN            NaN             Morocco   \n",
       "64898             NaN      NaN        NaN            NaN            Viet Nam   \n",
       "64925             NaN      NaN        NaN            NaN              Poland   \n",
       "65112             NaN      NaN        NaN            NaN               Spain   \n",
       "\n",
       "              CurrencyDesc CurrencySymbol  \\\n",
       "Respondent                                  \n",
       "1            European Euro            EUR   \n",
       "2           Pound sterling            GBP   \n",
       "3                      NaN            NaN   \n",
       "4             Albanian lek            ALL   \n",
       "5                      NaN            NaN   \n",
       "...                    ...            ...   \n",
       "64858                  NaN            NaN   \n",
       "64867                  NaN            NaN   \n",
       "64898                  NaN            NaN   \n",
       "64925                  NaN            NaN   \n",
       "65112                  NaN            NaN   \n",
       "\n",
       "                                       DatabaseDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "1                                        Microsoft SQL Server   \n",
       "2                                                         NaN   \n",
       "3                                                         NaN   \n",
       "4                                                         NaN   \n",
       "5                                            MySQL;PostgreSQL   \n",
       "...                                                       ...   \n",
       "64858                                                     NaN   \n",
       "64867       Cassandra;Couchbase;DynamoDB;Elasticsearch;Fir...   \n",
       "64898                                                     NaN   \n",
       "64925         DynamoDB;Elasticsearch;MongoDB;MySQL;PostgreSQL   \n",
       "65112                            MariaDB;Microsoft SQL Server   \n",
       "\n",
       "                                           DatabaseWorkedWith  \\\n",
       "Respondent                                                      \n",
       "1                   Elasticsearch;Microsoft SQL Server;Oracle   \n",
       "2                                                         NaN   \n",
       "3                                                         NaN   \n",
       "4                                                         NaN   \n",
       "5                               MySQL;PostgreSQL;Redis;SQLite   \n",
       "...                                                       ...   \n",
       "64858                                                     NaN   \n",
       "64867       Cassandra;Couchbase;DynamoDB;Elasticsearch;Fir...   \n",
       "64898                                                     NaN   \n",
       "64925                                                  Oracle   \n",
       "65112               MariaDB;Microsoft SQL Server;MySQL;Oracle   \n",
       "\n",
       "                                                      DevType  \\\n",
       "Respondent                                                      \n",
       "1           Developer, desktop or enterprise applications;...   \n",
       "2                     Developer, full-stack;Developer, mobile   \n",
       "3                                                         NaN   \n",
       "4                                                         NaN   \n",
       "5                                                         NaN   \n",
       "...                                                       ...   \n",
       "64858                                     Senior executive/VP   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925                                                     NaN   \n",
       "65112                                                     NaN   \n",
       "\n",
       "                                                    EdLevel  \\\n",
       "Respondent                                                    \n",
       "1           Master’s degree (M.A., M.S., M.Eng., MBA, etc.)   \n",
       "2              Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "3                                                       NaN   \n",
       "4           Master’s degree (M.A., M.S., M.Eng., MBA, etc.)   \n",
       "5              Bachelor’s degree (B.A., B.S., B.Eng., etc.)   \n",
       "...                                                     ...   \n",
       "64858       Master’s degree (M.A., M.S., M.Eng., MBA, etc.)   \n",
       "64867                                                   NaN   \n",
       "64898                             Primary/elementary school   \n",
       "64925                                                   NaN   \n",
       "65112            Other doctoral degree (Ph.D., Ed.D., etc.)   \n",
       "\n",
       "                                                   Employment  \\\n",
       "Respondent                                                      \n",
       "1           Independent contractor, freelancer, or self-em...   \n",
       "2                                          Employed full-time   \n",
       "3                                                         NaN   \n",
       "4                                                         NaN   \n",
       "5                                          Employed full-time   \n",
       "...                                                       ...   \n",
       "64858                                      Employed full-time   \n",
       "64867                                      Employed full-time   \n",
       "64898                                                     NaN   \n",
       "64925                                      Employed full-time   \n",
       "65112                                      Employed full-time   \n",
       "\n",
       "                               Ethnicity Gender  \\\n",
       "Respondent                                        \n",
       "1           White or of European descent    Man   \n",
       "2                                    NaN    NaN   \n",
       "3                                    NaN    NaN   \n",
       "4           White or of European descent    Man   \n",
       "5           White or of European descent    Man   \n",
       "...                                  ...    ...   \n",
       "64858                                NaN    NaN   \n",
       "64867                                NaN    NaN   \n",
       "64898                                NaN    NaN   \n",
       "64925                                NaN    NaN   \n",
       "65112                                NaN    NaN   \n",
       "\n",
       "                                                   JobFactors  \\\n",
       "Respondent                                                      \n",
       "1           Languages, frameworks, and other technologies ...   \n",
       "2                                                         NaN   \n",
       "3                                                         NaN   \n",
       "4           Flex time or a flexible schedule;Office enviro...   \n",
       "5                                                         NaN   \n",
       "...                                                       ...   \n",
       "64858                                                     NaN   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925                                                     NaN   \n",
       "65112                                                     NaN   \n",
       "\n",
       "                           JobSat  \\\n",
       "Respondent                          \n",
       "1              Slightly satisfied   \n",
       "2               Very dissatisfied   \n",
       "3                             NaN   \n",
       "4           Slightly dissatisfied   \n",
       "5                             NaN   \n",
       "...                           ...   \n",
       "64858                         NaN   \n",
       "64867                         NaN   \n",
       "64898                         NaN   \n",
       "64925                         NaN   \n",
       "65112                         NaN   \n",
       "\n",
       "                                                      JobSeek  \\\n",
       "Respondent                                                      \n",
       "1                I am not interested in new job opportunities   \n",
       "2                I am not interested in new job opportunities   \n",
       "3                                                         NaN   \n",
       "4           I’m not actively looking, but I am open to new...   \n",
       "5                                                         NaN   \n",
       "...                                                       ...   \n",
       "64858                                                     NaN   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925                                                     NaN   \n",
       "65112                                                     NaN   \n",
       "\n",
       "                                       LanguageDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "1                                      C#;HTML/CSS;JavaScript   \n",
       "2                                                Python;Swift   \n",
       "3                                    Objective-C;Python;Swift   \n",
       "4                                                         NaN   \n",
       "5                                             Java;Ruby;Scala   \n",
       "...                                                       ...   \n",
       "64858                                                     NaN   \n",
       "64867       Assembly;Bash/Shell/PowerShell;C;C#;C++;Dart;G...   \n",
       "64898                                                     NaN   \n",
       "64925                                HTML/CSS;Java;JavaScript   \n",
       "65112                         C#;HTML/CSS;Java;JavaScript;SQL   \n",
       "\n",
       "                                           LanguageWorkedWith  \\\n",
       "Respondent                                                      \n",
       "1                                      C#;HTML/CSS;JavaScript   \n",
       "2                                            JavaScript;Swift   \n",
       "3                                    Objective-C;Python;Swift   \n",
       "4                                                         NaN   \n",
       "5                                           HTML/CSS;Ruby;SQL   \n",
       "...                                                       ...   \n",
       "64858                                                     NaN   \n",
       "64867       Assembly;Bash/Shell/PowerShell;C;C#;C++;Dart;G...   \n",
       "64898                                                     NaN   \n",
       "64925                                                HTML/CSS   \n",
       "65112                         C#;HTML/CSS;Java;JavaScript;SQL   \n",
       "\n",
       "                      MiscTechDesireNextYear MiscTechWorkedWith  \\\n",
       "Respondent                                                        \n",
       "1                          .NET Core;Xamarin     .NET;.NET Core   \n",
       "2           React Native;TensorFlow;Unity 3D       React Native   \n",
       "3                                        NaN                NaN   \n",
       "4                                        NaN                NaN   \n",
       "5                               Ansible;Chef            Ansible   \n",
       "...                                      ...                ...   \n",
       "64858                                    NaN                NaN   \n",
       "64867                                    NaN                NaN   \n",
       "64898                                    NaN                NaN   \n",
       "64925                                Node.js                NaN   \n",
       "65112                      .NET Core;Xamarin     .NET;.NET Core   \n",
       "\n",
       "                      NEWCollabToolsDesireNextYear  \\\n",
       "Respondent                                           \n",
       "1           Microsoft Teams;Microsoft Azure;Trello   \n",
       "2                                     Github;Slack   \n",
       "3                                              NaN   \n",
       "4                                              NaN   \n",
       "5            Github;Google Suite (Docs, Meet, etc)   \n",
       "...                                            ...   \n",
       "64858                                          NaN   \n",
       "64867                                          NaN   \n",
       "64898                                          NaN   \n",
       "64925                                Github;Gitlab   \n",
       "65112                       Github;Microsoft Teams   \n",
       "\n",
       "                                     NEWCollabToolsWorkedWith NEWDevOps  \\\n",
       "Respondent                                                                \n",
       "1                Confluence;Jira;Slack;Microsoft Azure;Trello        No   \n",
       "2                         Confluence;Jira;Github;Gitlab;Slack       NaN   \n",
       "3                                                         NaN       NaN   \n",
       "4                                                         NaN        No   \n",
       "5           Confluence;Jira;Github;Slack;Google Suite (Doc...       NaN   \n",
       "...                                                       ...       ...   \n",
       "64858                                                     NaN       NaN   \n",
       "64867                                                     NaN       NaN   \n",
       "64898                                                     NaN       NaN   \n",
       "64925                   Confluence;Jira;Slack;Microsoft Teams       NaN   \n",
       "65112                                                  Github       NaN   \n",
       "\n",
       "                 NEWDevOpsImpt                           NEWEdImpt  \\\n",
       "Respondent                                                           \n",
       "1           Somewhat important                    Fairly important   \n",
       "2                          NaN                    Fairly important   \n",
       "3                          NaN                                 NaN   \n",
       "4                          NaN  Not at all important/not necessary   \n",
       "5                          NaN                      Very important   \n",
       "...                        ...                                 ...   \n",
       "64858                      NaN                      Very important   \n",
       "64867                      NaN                                 NaN   \n",
       "64898                      NaN                                 NaN   \n",
       "64925                      NaN                                 NaN   \n",
       "65112                      NaN                Critically important   \n",
       "\n",
       "                                                   NEWJobHunt  \\\n",
       "Respondent                                                      \n",
       "1                                                         NaN   \n",
       "2                                                         NaN   \n",
       "3                                                         NaN   \n",
       "4           Curious about other opportunities;Wanting to w...   \n",
       "5                                                         NaN   \n",
       "...                                                       ...   \n",
       "64858                                                     NaN   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925                                                     NaN   \n",
       "65112                                                     NaN   \n",
       "\n",
       "           NEWJobHuntResearch       NEWLearn NEWOffTopic NEWOnboardGood  \\\n",
       "Respondent                                                                \n",
       "1                         NaN    Once a year    Not sure            NaN   \n",
       "2                         NaN    Once a year    Not sure            NaN   \n",
       "3                         NaN  Once a decade         NaN            NaN   \n",
       "4                         NaN    Once a year    Not sure            Yes   \n",
       "5                         NaN    Once a year          No            NaN   \n",
       "...                       ...            ...         ...            ...   \n",
       "64858                     NaN  Once a decade         NaN            NaN   \n",
       "64867                     NaN            NaN         NaN            NaN   \n",
       "64898                     NaN            NaN         NaN            NaN   \n",
       "64925                     NaN    Once a year         NaN            NaN   \n",
       "65112                     NaN    Once a year         NaN            NaN   \n",
       "\n",
       "           NEWOtherComms                                        NEWOvertime  \\\n",
       "Respondent                                                                    \n",
       "1                     No                   Often: 1-2 days per week or more   \n",
       "2                     No                                                NaN   \n",
       "3                     No                                                NaN   \n",
       "4                    Yes  Occasionally: 1-2 days per quarter but less th...   \n",
       "5                    Yes                                                NaN   \n",
       "...                  ...                                                ...   \n",
       "64858                NaN                                                NaN   \n",
       "64867                NaN                                                NaN   \n",
       "64898                NaN                                                NaN   \n",
       "64925                NaN                                                NaN   \n",
       "65112                NaN                                                NaN   \n",
       "\n",
       "                                          NEWPurchaseResearch  \\\n",
       "Respondent                                                      \n",
       "1           Start a free trial;Ask developers I know/work ...   \n",
       "2                                                         NaN   \n",
       "3                                                         NaN   \n",
       "4                                                         NaN   \n",
       "5           Start a free trial;Ask developers I know/work ...   \n",
       "...                                                       ...   \n",
       "64858                                      Start a free trial   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925                                      Start a free trial   \n",
       "65112       Start a free trial;Ask developers I know/work ...   \n",
       "\n",
       "                NEWPurpleLink  \\\n",
       "Respondent                      \n",
       "1                      Amused   \n",
       "2                      Amused   \n",
       "3                         NaN   \n",
       "4                         NaN   \n",
       "5           Hello, old friend   \n",
       "...                       ...   \n",
       "64858                  Amused   \n",
       "64867                     NaN   \n",
       "64898                     NaN   \n",
       "64925       Hello, old friend   \n",
       "65112             Indifferent   \n",
       "\n",
       "                                                   NEWSOSites  \\\n",
       "Respondent                                                      \n",
       "1            Stack Overflow (public Q&A for anyone who codes)   \n",
       "2           Stack Overflow (public Q&A for anyone who code...   \n",
       "3            Stack Overflow (public Q&A for anyone who codes)   \n",
       "4           Stack Overflow (public Q&A for anyone who code...   \n",
       "5           Stack Overflow (public Q&A for anyone who code...   \n",
       "...                                                       ...   \n",
       "64858        Stack Overflow (public Q&A for anyone who codes)   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925        Stack Overflow (public Q&A for anyone who codes)   \n",
       "65112                                                     NaN   \n",
       "\n",
       "                                                     NEWStuck        OpSys  \\\n",
       "Respondent                                                                   \n",
       "1           Visit Stack Overflow;Go for a walk or other ph...      Windows   \n",
       "2           Visit Stack Overflow;Go for a walk or other ph...        MacOS   \n",
       "3                                                         NaN  Linux-based   \n",
       "4                                                         NaN  Linux-based   \n",
       "5           Call a coworker or friend;Visit Stack Overflow...      Windows   \n",
       "...                                                       ...          ...   \n",
       "64858                               Call a coworker or friend      Windows   \n",
       "64867                                                     NaN          NaN   \n",
       "64898                                                     NaN          NaN   \n",
       "64925          Call a coworker or friend;Visit Stack Overflow      Windows   \n",
       "65112       Meditate;Visit Stack Overflow;Go for a walk or...      Windows   \n",
       "\n",
       "                             OrgSize  \\\n",
       "Respondent                             \n",
       "1                   2 to 9 employees   \n",
       "2           1,000 to 4,999 employees   \n",
       "3                                NaN   \n",
       "4                 20 to 99 employees   \n",
       "5                                NaN   \n",
       "...                              ...   \n",
       "64858                            NaN   \n",
       "64867                            NaN   \n",
       "64898                            NaN   \n",
       "64925                            NaN   \n",
       "65112                            NaN   \n",
       "\n",
       "                                       PlatformDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "1              Android;iOS;Kubernetes;Microsoft Azure;Windows   \n",
       "2                                  iOS;Kubernetes;Linux;MacOS   \n",
       "3                                                         NaN   \n",
       "4                                                         NaN   \n",
       "5           Docker;Google Cloud Platform;Heroku;Linux;Windows   \n",
       "...                                                       ...   \n",
       "64858                                                     NaN   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925                                                     NaN   \n",
       "65112                      Arduino;Linux;Raspberry Pi;Windows   \n",
       "\n",
       "                                    PlatformWorkedWith  \\\n",
       "Respondent                                               \n",
       "1                                              Windows   \n",
       "2                                                  iOS   \n",
       "3                                                  NaN   \n",
       "4                                                  NaN   \n",
       "5                       AWS;Docker;Linux;MacOS;Windows   \n",
       "...                                                ...   \n",
       "64858                                              NaN   \n",
       "64867                                              NaN   \n",
       "64898                                              NaN   \n",
       "64925                                    Linux;Windows   \n",
       "65112       Android;Arduino;Linux;Raspberry Pi;Windows   \n",
       "\n",
       "                                PurchaseWhat                Sexuality  \\\n",
       "Respondent                                                              \n",
       "1                                        NaN  Straight / Heterosexual   \n",
       "2              I have little or no influence                      NaN   \n",
       "3                                        NaN                      NaN   \n",
       "4           I have a great deal of influence  Straight / Heterosexual   \n",
       "5                                        NaN  Straight / Heterosexual   \n",
       "...                                      ...                      ...   \n",
       "64858                                    NaN                      NaN   \n",
       "64867                                    NaN                      NaN   \n",
       "64898                                    NaN                      NaN   \n",
       "64925                                    NaN                      NaN   \n",
       "65112                                    NaN                      NaN   \n",
       "\n",
       "           SOAccount           SOComm                           SOPartFreq  \\\n",
       "Respondent                                                                   \n",
       "1                 No   No, not at all                                  NaN   \n",
       "2                Yes  Yes, definitely  Less than once per month or monthly   \n",
       "3                Yes    Yes, somewhat      A few times per month or weekly   \n",
       "4                Yes  Yes, definitely      A few times per month or weekly   \n",
       "5                Yes    Yes, somewhat  Less than once per month or monthly   \n",
       "...              ...              ...                                  ...   \n",
       "64858            NaN              NaN                                  NaN   \n",
       "64867            NaN              NaN                                  NaN   \n",
       "64898            NaN              NaN                                  NaN   \n",
       "64925            NaN              NaN                                  NaN   \n",
       "65112            NaN              NaN                                  NaN   \n",
       "\n",
       "                                SOVisitFreq                  SurveyEase  \\\n",
       "Respondent                                                                \n",
       "1                    Multiple times per day  Neither easy nor difficult   \n",
       "2                    Multiple times per day                         NaN   \n",
       "3                     Daily or almost daily  Neither easy nor difficult   \n",
       "4                    Multiple times per day                         NaN   \n",
       "5           A few times per month or weekly                        Easy   \n",
       "...                                     ...                         ...   \n",
       "64858                                   NaN                         NaN   \n",
       "64867                                   NaN                         NaN   \n",
       "64898                                   NaN                         NaN   \n",
       "64925                                   NaN                         NaN   \n",
       "65112                                   NaN                         NaN   \n",
       "\n",
       "                     SurveyLength Trans  \\\n",
       "Respondent                                \n",
       "1           Appropriate in length    No   \n",
       "2                             NaN   NaN   \n",
       "3           Appropriate in length   NaN   \n",
       "4                             NaN    No   \n",
       "5                       Too short    No   \n",
       "...                           ...   ...   \n",
       "64858                         NaN   NaN   \n",
       "64867                         NaN   NaN   \n",
       "64898                         NaN   NaN   \n",
       "64925                         NaN   NaN   \n",
       "65112                         NaN   NaN   \n",
       "\n",
       "                                               UndergradMajor  \\\n",
       "Respondent                                                      \n",
       "1           Computer science, computer engineering, or sof...   \n",
       "2           Computer science, computer engineering, or sof...   \n",
       "3                                                         NaN   \n",
       "4           Computer science, computer engineering, or sof...   \n",
       "5           Computer science, computer engineering, or sof...   \n",
       "...                                                       ...   \n",
       "64858       Computer science, computer engineering, or sof...   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925                                                     NaN   \n",
       "65112       Computer science, computer engineering, or sof...   \n",
       "\n",
       "                 WebframeDesireNextYear  \\\n",
       "Respondent                                \n",
       "1                          ASP.NET Core   \n",
       "2                                   NaN   \n",
       "3                                   NaN   \n",
       "4                                   NaN   \n",
       "5                  Django;Ruby on Rails   \n",
       "...                                 ...   \n",
       "64858                               NaN   \n",
       "64867                               NaN   \n",
       "64898                               NaN   \n",
       "64925       Angular;Angular.js;React.js   \n",
       "65112               ASP.NET Core;jQuery   \n",
       "\n",
       "                                WebframeWorkedWith  \\\n",
       "Respondent                                           \n",
       "1                             ASP.NET;ASP.NET Core   \n",
       "2                                              NaN   \n",
       "3                                              NaN   \n",
       "4                                              NaN   \n",
       "5                                    Ruby on Rails   \n",
       "...                                            ...   \n",
       "64858                                          NaN   \n",
       "64867                                          NaN   \n",
       "64898                                          NaN   \n",
       "64925                                          NaN   \n",
       "65112       Angular;Angular.js;ASP.NET Core;jQuery   \n",
       "\n",
       "                                       WelcomeChange  WorkWeekHrs YearsCode  \\\n",
       "Respondent                                                                    \n",
       "1            Just as welcome now as I felt last year         50.0        36   \n",
       "2           Somewhat more welcome now than last year          NaN         7   \n",
       "3           Somewhat more welcome now than last year          NaN         4   \n",
       "4           Somewhat less welcome now than last year         40.0         7   \n",
       "5            Just as welcome now as I felt last year          NaN        15   \n",
       "...                                              ...          ...       ...   \n",
       "64858                                            NaN          NaN        10   \n",
       "64867                                            NaN          NaN       NaN   \n",
       "64898                                            NaN          NaN       NaN   \n",
       "64925                                            NaN          NaN       NaN   \n",
       "65112                                            NaN          NaN       NaN   \n",
       "\n",
       "                YearsCodePro  \n",
       "Respondent                    \n",
       "1                         27  \n",
       "2                          4  \n",
       "3                        NaN  \n",
       "4                          4  \n",
       "5                          8  \n",
       "...                      ...  \n",
       "64858       Less than 1 year  \n",
       "64867                    NaN  \n",
       "64898                    NaN  \n",
       "64925                    NaN  \n",
       "65112                    NaN  \n",
       "\n",
       "[64461 rows x 60 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "1                   36\n",
       "2                    7\n",
       "3                    4\n",
       "4                    7\n",
       "5                   15\n",
       "6                    6\n",
       "7                    6\n",
       "8                   17\n",
       "9                    6\n",
       "10                   8\n",
       "11                  10\n",
       "12                   7\n",
       "13                  35\n",
       "14                   5\n",
       "15                   4\n",
       "16                  37\n",
       "17                   7\n",
       "18                  19\n",
       "19                   9\n",
       "20                  22\n",
       "21                   7\n",
       "22                  10\n",
       "23                   8\n",
       "24                  30\n",
       "25                  23\n",
       "26                  17\n",
       "27                  20\n",
       "28                   2\n",
       "29    Less than 1 year\n",
       "30                   4\n",
       "31                   6\n",
       "32                  19\n",
       "33                  20\n",
       "34                  10\n",
       "35                   3\n",
       "36                   4\n",
       "37                   2\n",
       "38                  20\n",
       "39                  13\n",
       "40                   6\n",
       "41                  25\n",
       "42                  16\n",
       "43                  36\n",
       "44                  10\n",
       "45                   9\n",
       "46                   6\n",
       "47                  43\n",
       "48                   8\n",
       "49                   8\n",
       "50                  10\n",
       "Name: YearsCode, dtype: object"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"YearsCode\"].head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['36', '7', '4', '15', '6', '17', '8', '10', '35', '5', '37', '19',\n",
       "       '9', '22', '30', '23', '20', '2', 'Less than 1 year', '3', '13',\n",
       "       '25', '16', '43', '11', '38', '33', nan, '24', '21', '12', '40',\n",
       "       '27', '50', '46', '14', '18', '28', '32', '44', '26', '42', '31',\n",
       "       '34', '29', '1', '39', '41', '45', 'More than 50 years', '47',\n",
       "       '49', '48'], dtype=object)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"YearsCode\"].unique() # shows unique values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"YearsCode\"].replace(\"Less than 1 year\", 0, inplace = True) # replaceing values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"YearsCode\"].replace(\"More than 50 years\", 51, inplace = True) # replaceing values also"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "1     36\n",
       "2      7\n",
       "3      4\n",
       "4      7\n",
       "5     15\n",
       "6      6\n",
       "7      6\n",
       "8     17\n",
       "9      6\n",
       "10     8\n",
       "11    10\n",
       "12     7\n",
       "13    35\n",
       "14     5\n",
       "15     4\n",
       "16    37\n",
       "17     7\n",
       "18    19\n",
       "19     9\n",
       "20    22\n",
       "21     7\n",
       "22    10\n",
       "23     8\n",
       "24    30\n",
       "25    23\n",
       "26    17\n",
       "27    20\n",
       "28     2\n",
       "29     0\n",
       "30     4\n",
       "31     6\n",
       "32    19\n",
       "33    20\n",
       "34    10\n",
       "35     3\n",
       "36     4\n",
       "37     2\n",
       "38    20\n",
       "39    13\n",
       "40     6\n",
       "41    25\n",
       "42    16\n",
       "43    36\n",
       "44    10\n",
       "45     9\n",
       "46     6\n",
       "47    43\n",
       "48     8\n",
       "49     8\n",
       "50    10\n",
       "Name: YearsCode, dtype: object"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"YearsCode\"].head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['36', '7', '4', '15', '6', '17', '8', '10', '35', '5', '37', '19',\n",
       "       '9', '22', '30', '23', '20', '2', 0, '3', '13', '25', '16', '43',\n",
       "       '11', '38', '33', nan, '24', '21', '12', '40', '27', '50', '46',\n",
       "       '14', '18', '28', '32', '44', '26', '42', '31', '34', '29', '1',\n",
       "       '39', '41', '45', 51, '47', '49', '48'], dtype=object)"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"YearsCode\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"YearsCode\"] = df[\"YearsCode\"].astype(float) # changine type to float"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "12.709052770265584"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"YearsCode\"].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    57684.000000\n",
       "mean        12.709053\n",
       "std          9.717353\n",
       "min          0.000000\n",
       "25%          6.000000\n",
       "50%         10.000000\n",
       "75%         17.000000\n",
       "max         51.000000\n",
       "Name: YearsCode, dtype: float64"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"YearsCode\"].describe() # data for experience"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10.0"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[\"YearsCode\"].median()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3rc1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
